ISO Week Number from today()

Has anyone by any chance got DXL which calculates the current ISO week number from today() they can share ?


BillTidy - Mon Jun 03 04:01:53 EDT 2013

Re: ISO Week Number from today()
Tony_Goodman - Tue Jun 04 05:02:23 EDT 2013

Hi Bill,

I have never needed to know what the week number is, but it was interesting to discover how the ISO week numbers are calculated.

I think the attached is correct, at least it passed all the dates I tested.

 


Attachments

getISOWeekNumber.dxl

Re: ISO Week Number from today()
BillTidy - Fri Jun 07 14:31:49 EDT 2013

Tony_Goodman - Tue Jun 04 05:02:23 EDT 2013

Hi Bill,

I have never needed to know what the week number is, but it was interesting to discover how the ISO week numbers are calculated.

I think the attached is correct, at least it passed all the dates I tested.

 

Tony,

Thanks very much for that.